Confirm Delete?
Are you sure you want to remove from the report?

Data Preview

Tail

  lock_status carrier business_unit sales_person sku quantity order_type first_time_customer tgt_enc_sim_impt_x0 unit_cost model_family tgt_enc_sim_impt_x2 color days_since_last_purchase tgt_enc_sim_impt_x1 memory_size condition channel brand unit_price
139842 135.232066 137.595979 900.000000 119.852983 156.222221 4.000000 133.414677 0.000000 162.706079 153.000000 137.066068 141.795103 148.029814 0.000000 130.001970 84.349338 231.236690 132.120897 138.128169 160.000000
139843 135.232066 137.595979 900.000000 119.852983 137.783282 1.000000 133.414677 0.000000 128.068295 97.006000 145.785332 142.455969 138.248964 0.000000 130.001970 155.582144 120.342959 132.120897 138.128169 130.000000
139844 135.232066 137.595979 900.000000 149.058176 96.274460 1.000000 133.414677 0.000000 162.706079 125.999000 142.682683 163.237457 138.248964 0.000000 130.001970 110.841853 100.957235 132.120897 138.128169 90.000000
139845 135.232066 137.595979 900.000000 119.852983 31.300885 1.000000 133.414677 0.000000 82.853069 25.000000 34.077742 33.074447 153.495556 0.000000 130.001970 84.349338 110.142066 132.120897 138.128169 35.000000
139846 135.232066 92.100800 900.000000 119.852983 109.477298 1.000000 133.414677 0.000000 128.068295 78.277000 113.284406 89.452952 148.029814 0.000000 130.001970 179.528718 120.342959 90.690402 138.128169 105.000000

Pre Processing

Pre Processing - Imputations

Pre Processing - Imputations - Missing

No missing values in data

Pre Processing - Imputations - Infinitys

No Infinity values

Health Analysis

Health Plot

Missing Plot

Missing Value Summary

No Missing Values

Duplicate Columns

No duplicate variables

Outliers In Features

  N < (mean-3*std) > (mean+3*std) < (1stQ - 1.5 * IQR) > (3rdQ + 1.5 * IQR) -inf +inf
Feature              
lock_status 139847 158 0 158 4657 0 0
carrier 139847 5476 1963 9029 1963 0 0
business_unit 139847 7257 0 8515 8822 0 0
sales_person 139847 0 743 6 5702 0 0
sku 139847 0 2930 0 11243 0 0
quantity 139847 3 2357 169 15321 0 0
order_type 139847 0 4040 0 4040 0 0
first_time_customer 139847 0 4281 0 4281 0 0
tgt_enc_sim_impt_x0 139847 2266 0 2266 0 0 0
unit_cost 139847 0 3506 0 8502 0 0
model_family 139847 0 2898 0 10368 0 0
tgt_enc_sim_impt_x2 139847 0 2742 0 9948 0 0
color 139847 442 2618 10700 4853 0 0
days_since_last_purchase 139847 0 1743 0 2372 0 0
tgt_enc_sim_impt_x1 139847 0 10447 0 13543 0 0
memory_size 139847 0 8094 0 8094 0 0
condition 139847 0 1210 222 1210 0 0
channel 139847 0 2674 9216 6247 0 0
brand 139847 5604 0 5604 0 0 0
unit_price 139847 0 2853 0 10408 0 0

Feature Analysis

Summary Stats

Summary Stats - Numeric Variables

  Variable Name Datatype No of Unique Samples Mean Standard Deviation Min 25th percentile Median 75th percentile Max
0 brand float64 2 [138.12816902184844, 89.490665064904] 136.179149 9.539257 89.490665 138.128169 138.128169 138.128169 138.128169
1 business_unit float64 10 [900.0, 904.0, 922.0, 480.32456422234065, 700.0] 876.751553 96.450346 480.324564 900.000000 900.000000 900.000000 935.000000
2 carrier float64 8 [137.59597888324086, 177.39227812657035, 93.08839858691479, 102.37927751834557, 97.88573248407643] 135.498681 11.327105 93.088399 137.595979 137.595979 137.595979 177.392278
3 channel float64 10 [132.12089741445845, 90.69040233666061, 146.6541923213651, 253.23132451965603, 81.386081300813] 132.367100 20.648167 68.406667 132.120897 132.120897 132.120897 253.231325
4 color float64 30 [138.2489639738742, 153.49555624450124, 58.65695707295374, 143.25272264133372, 103.57299342820437] 134.451534 33.019880 25.816035 120.758911 143.252723 148.029814 244.667803
5 condition float64 21 [110.1420661978082, 100.95723477538753, 120.34295941861212, 202.48760250482823, 195.4376402502607] 134.586005 42.791594 7.664739 110.142066 110.142066 165.638901 272.005940
6 days_since_last_purchase float64 3 [0.0, 1.8959041358031585, 1.0] 0.028128 0.220243 0.000000 0.000000 0.000000 0.000000 1.895904
7 first_time_customer float64 2 [0.0, 0.29965361163909293] 0.009173 0.051620 0.000000 0.000000 0.000000 0.000000 0.299654
8 lock_status float64 3 [135.23206602138754, 137.17599248443202, 129.99489380266414] 135.290883 0.391623 129.994894 135.232066 135.232066 135.232066 137.175992
9 memory_size float64 11 [110.84185308027186, 72.01804319654427, 84.34933772269558, 179.52871822004528, 155.5821439437734] 134.165864 64.151608 23.378892 84.349338 110.841853 155.582144 338.974196
10 model_family float64 183 [139.79359246088194, 69.55733681145352, 106.50990083905417, 86.0514243792325, 48.217917996870106] 132.820228 95.165548 8.369396 69.557337 98.612845 156.515299 451.812826
11 order_type float64 2 [133.41467696068688, 167.0326171114319] 134.385856 5.630815 133.414677 133.414677 133.414677 133.414677 167.032617
12 quantity float64 171 [100.0, 20.0, 1.0, 8.0, 2.0] 8.822181 20.775175 -107.054555 1.000000 2.000000 7.000000 129.699468
13 sales_person float64 13 [149.05817598516106, 119.85298332309411, 145.4403729333729, 216.8189755122439, 210.42307692307693] 134.679332 24.201388 70.436637 119.852983 119.852983 149.058176 221.810979
14 sku float64 5730 [141.9742571428571, 59.92203050847458, 106.47787610619469, 87.042071197411, 52.97278911564626] 132.002543 94.591170 5.322033 65.631579 106.265851 157.846154 446.975274
15 tgt_enc_sim_impt_x0 float64 6 [128.0682946896036, 162.70607912677693, 82.85306886929344, 110.55211495629797, 171.44040834473324] 135.279436 26.600705 55.069065 128.068295 128.068295 162.706079 171.440408
16 tgt_enc_sim_impt_x1 float64 4 [130.0019700247023, 188.21983426727854, 139.89883877221325, 135.23926336639326] 134.570091 15.313211 130.001970 130.001970 130.001970 130.001970 188.219834
17 tgt_enc_sim_impt_x2 float64 166 [142.45596918511757, 78.99624829584185, 105.99506735751297, 81.79102022315203, 57.04693107344633] 132.572601 89.141895 7.369442 79.315704 96.965945 160.409558 437.301406
18 unit_cost float64 39859 [160.49, 62.999, 68.086, 58.136, 37.691] 108.112298 83.779436 0.000000 49.865000 80.354000 139.534500 370.983182
19 unit_price float64 1800 [170.0, 55.0, 110.0, 88.0, 51.0] 135.239263 112.507163 0.000000 63.659000 100.000000 165.000000 1159.000000

Summary Stats - Non Numeric Variables

No categorical columns

Distributions

Distributions - Numeric Variables

Distributions - Numeric Variables - Brand

Distributions - Numeric Variables - Business Unit

Distributions - Numeric Variables - Carrier

Distributions - Numeric Variables - Channel

Distributions - Numeric Variables - Color

Distributions - Numeric Variables - Condition

Distributions - Numeric Variables - Days Since Last Purchase

Distributions - Numeric Variables - First Time Customer

Distributions - Numeric Variables - Lock Status

Distributions - Numeric Variables - Memory Size

Distributions - Numeric Variables - Model Family

Distributions - Numeric Variables - Order Type

Distributions - Numeric Variables - Quantity

Distributions - Numeric Variables - Sales Person

Distributions - Numeric Variables - Sku

Distributions - Numeric Variables - Tgt Enc Sim Impt X0

Distributions - Numeric Variables - Tgt Enc Sim Impt X1

Distributions - Numeric Variables - Tgt Enc Sim Impt X2

Distributions - Numeric Variables - Unit Cost

Distributions - Numeric Variables - Unit Price

Distributions - Non Numeric Variables

No categorical variables in data.

Feature Normality

Feature Interactions

Correlation Table

  Variable 1 Variable 2 Corr Coef Abs Corr Coef
0 sku unit_price 0.924854 0.924854
1 unit_price sku 0.924854 0.924854
2 model_family unit_price 0.919086 0.919086
3 unit_price model_family 0.919086 0.919086
4 unit_price tgt_enc_sim_impt_x2 0.873985 0.873985
5 tgt_enc_sim_impt_x2 unit_price 0.873985 0.873985
6 unit_price unit_cost 0.867702 0.867702
7 unit_cost unit_price 0.867702 0.867702
8 unit_price memory_size 0.600660 0.600660
9 memory_size unit_price 0.600660 0.600660
10 unit_price condition 0.399041 0.399041
11 condition unit_price 0.399041 0.399041
12 channel unit_price 0.332982 0.332982
13 unit_price channel 0.332982 0.332982
14 unit_price color 0.318499 0.318499
15 color unit_price 0.318499 0.318499
16 tgt_enc_sim_impt_x0 unit_price 0.237512 0.237512
17 unit_price tgt_enc_sim_impt_x0 0.237512 0.237512
18 sales_person unit_price 0.233028 0.233028
19 unit_price sales_person 0.233028 0.233028
20 tgt_enc_sim_impt_x1 unit_price 0.156956 0.156956
21 unit_price tgt_enc_sim_impt_x1 0.156956 0.156956
22 brand unit_price 0.125676 0.125676
23 unit_price brand 0.125676 0.125676
24 quantity unit_price 0.124464 0.124464
25 unit_price quantity 0.124464 0.124464
26 unit_price carrier 0.122385 0.122385
27 carrier unit_price 0.122385 0.122385
28 unit_price business_unit -0.095195 0.095195
29 business_unit unit_price -0.095195 0.095195
30 unit_price order_type 0.094028 0.094028
31 order_type unit_price 0.094028 0.094028
32 unit_price first_time_customer 0.070741 0.070741
33 first_time_customer unit_price 0.070741 0.070741
34 unit_price days_since_last_purchase 0.061948 0.061948
35 days_since_last_purchase unit_price 0.061948 0.061948
36 unit_price lock_status 0.009686 0.009686
37 lock_status unit_price 0.009686 0.009686

Correlation Heatmap

Covariance Heatmap

Bivariate Plots (top 50 Correlations)

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X2 Vs Model Family

Bivariate Plots (top 50 Correlations) - Sku Vs Model Family

Bivariate Plots (top 50 Correlations) - Unit Price Vs Sku

Bivariate Plots (top 50 Correlations) - Unit Price Vs Model Family

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X2 Vs Sku

Bivariate Plots (top 50 Correlations) - Unit Price Vs Tgt Enc Sim Impt X2

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Sku

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Model Family

Bivariate Plots (top 50 Correlations) - Unit Price Vs Unit Cost

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Tgt Enc Sim Impt X2

Bivariate Plots (top 50 Correlations) - Model Family Vs Memory Size

Bivariate Plots (top 50 Correlations) - Sku Vs Memory Size

Bivariate Plots (top 50 Correlations) - Unit Price Vs Memory Size

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Memory Size

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X2 Vs Memory Size

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X1 Vs Sales Person

Bivariate Plots (top 50 Correlations) - Carrier Vs Brand

Bivariate Plots (top 50 Correlations) - Sku Vs Condition

Bivariate Plots (top 50 Correlations) - Unit Price Vs Condition

Bivariate Plots (top 50 Correlations) - Model Family Vs Color

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Channel

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Condition

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X1 Vs Condition

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Color

Bivariate Plots (top 50 Correlations) - Sku Vs Color

Bivariate Plots (top 50 Correlations) - Unit Price Vs Channel

Bivariate Plots (top 50 Correlations) - Channel Vs Carrier

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X2 Vs Color

Bivariate Plots (top 50 Correlations) - Sales Person Vs Condition

Bivariate Plots (top 50 Correlations) - Unit Price Vs Color

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X1 Vs Order Type

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X2 Vs Tgt Enc Sim Impt X0

Bivariate Plots (top 50 Correlations) - Condition Vs Channel

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Sales Person

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Tgt Enc Sim Impt X0

Bivariate Plots (top 50 Correlations) - Model Family Vs Channel

Bivariate Plots (top 50 Correlations) - Quantity Vs Channel

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X0 Vs Model Family

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X0 Vs Sku

Bivariate Plots (top 50 Correlations) - Sku Vs Channel

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X2 Vs Condition

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X2 Vs Channel

Bivariate Plots (top 50 Correlations) - Memory Size Vs Color

Bivariate Plots (top 50 Correlations) - Unit Price Vs Tgt Enc Sim Impt X0

Bivariate Plots (top 50 Correlations) - Model Family Vs Condition

Bivariate Plots (top 50 Correlations) - Unit Price Vs Sales Person

Bivariate Plots (top 50 Correlations) - Channel Vs Brand

Bivariate Plots (top 50 Correlations) - Sku Vs Sales Person

Bivariate Plots (top 50 Correlations) - Color Vs Brand

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt X0 Vs Memory Size

Key Drivers

Unit Price

Unit Price - Feature Scores - Feature Correlation

Unit Price - Feature Importances - From Model

Unit Price - Pca Analysis

Unit Price - Pca Analysis - Pca Projection

Unit Price - Pca Analysis - Correlation With Dimension 2 (y)

Unit Price - Pca Analysis - Correlation With Dimension 1 (x)

Unit Price - Bivariate Plots

Unit Price - Bivariate Plots - Lock Status

Unit Price - Bivariate Plots - Carrier

Unit Price - Bivariate Plots - Business Unit

Unit Price - Bivariate Plots - Sales Person

Unit Price - Bivariate Plots - Sku

Unit Price - Bivariate Plots - Quantity

Unit Price - Bivariate Plots - Order Type

Unit Price - Bivariate Plots - First Time Customer

Unit Price - Bivariate Plots - Tgt Enc Sim Impt X0

Unit Price - Bivariate Plots - Unit Cost

Unit Price - Bivariate Plots - Model Family

Unit Price - Bivariate Plots - Tgt Enc Sim Impt X2

Unit Price - Bivariate Plots - Color

Unit Price - Bivariate Plots - Days Since Last Purchase

Unit Price - Bivariate Plots - Tgt Enc Sim Impt X1

Unit Price - Bivariate Plots - Memory Size

Unit Price - Bivariate Plots - Condition

Unit Price - Bivariate Plots - Channel

Unit Price - Bivariate Plots - Brand